package sybh.sww.jdbc;

public class AppTest {
    public static void main(String[] args){
        int i=0;
        i=JdbcUtils.update("INSERT INTO `user`(username,`PASSWORD`)VALUES('lmx',MD5('111'))");
        if(i>0){
            System.out.println("插入成功！");
        }

        i=JdbcUtils.update("UPDATE `user` SET `username` = 'Jekins' WHERE id = 7;");
        if(i>0){
            System.out.println("修改成功！");
        }

        i=JdbcUtils.update("DELETE FROM `user`  WHERE id = 6;");
        if(i>0){
            System.out.println("删除成功！");
        }

        JdbcUtils.select("SELECT id,username FROM `user` ORDER BY id");

    }
}
